package com.ruoyi.db.mapper;

import java.util.List;
import java.util.Map;

import com.ruoyi.db.domain.MemberSourceInfo;
import com.ruoyi.db.domain.SourceMemberDataInfoHistory;
import org.apache.ibatis.annotations.Param;

/**
 * 用户资质信息Mapper接口
 *
 * @author ruoyi
 * @date 2023-08-13
 */
public interface MemberSourceInfoMapper {
    /**
     * 查询用户资质信息
     *
     * @param uid 用户资质信息主键
     * @return 用户资质信息
     */
    public MemberSourceInfo selectMemberSourceInfoByUid(Long uid);

    public List<Map<String, Object>> selectMemberSourceInfoByChannelCode(MemberSourceInfo memberSourceInfo);

    public List<Map<String, Object>> selectAgeByChannelCode(MemberSourceInfo memberSourceInfo);

    public List<Map<String, Object>> selectZhiMaList1(MemberSourceInfo memberSourceInfo);

    String selectAllZhiMaList(MemberSourceInfo memberSourceInfo);

    public List<Map<String, Object>> selectProvinceByChannelCode(MemberSourceInfo memberSourceInfo);


    List<Map<String, Object>> getCityCount(MemberSourceInfo memberSourceInfo);
    List<Map<String, Object>> getCity(MemberSourceInfo memberSourceInfo);


    /**
     * 新增用户资质信息
     *
     * @param memberSourceInfo 用户资质信息
     * @return 结果
     */
    public int insertMemberSourceInfo(MemberSourceInfo memberSourceInfo);

    /**
     * 修改用户资质信息
     *
     * @param memberSourceInfo 用户资质信息
     * @return 结果
     */
    public int updateMemberSourceInfo(MemberSourceInfo memberSourceInfo);

    /**
     * 删除用户资质信息
     *
     * @param uid 用户资质信息主键
     * @return 结果
     */
    public int deleteMemberSourceInfoByUid(Long uid);

    /**
     * 批量删除用户资质信息
     *
     * @param uids 需要删除的数据主键集合
     * @return 结果
     */
    public int deleteMemberSourceInfoByUids(Long[] uids);

    List<Map<String, Object>> selectMemberSourceInfoMapList(MemberSourceInfo memberSourceInfo);

    List<Map<String, Object>> selectMemberSourceInfoCardList(MemberSourceInfo memberSourceInfo);

    List<Map<String, Object>> selectAllzhima(@Param("startDate") String dateInfo, @Param("endDate") String endDate);

    List<Map<String, Object>> selectzhima(@Param("dateInfo") String dateInfo);

    public Long countAuthNumber(@Param("dateInfo") String dateInfo);

    public Long countAllumber(@Param("startDate") String dateInfo, @Param("endDate") String endDate);

    Long countNumberByDate(@Param("startDate") String startDate, @Param("endDate") String endDate);

    List<Map<String, Object>> selectWuYongCount(MemberSourceInfo memberSourceInfo);

    List<Map<String, Object>> upload(@Param("md5List") List<String> md5List);
}
